home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI539.ASC
< prev
next >
Wrap
Text File
|
1993-05-07
|
3KB
|
133 lines
PRODUCT : Paradox NUMBER : 539
VERSION : 3.0 & up
OS : DOS
DATE : May 7, 1993 PAGE : 1/2
TITLE : Placing a Variable in a Report
Intended Audience:
All Paradox users
Prerequisites:
You should be familiar with how to link tables in a report.
Purpose of the TI:
This document illustrates how to place a variable in a report by
using a lookup table to hold the variable.
1. Create a table called VARIABLE with the following fields:
╔═════Field Name════╦═Type═╗
║ Variable Link ║ A1* ║
║ Variable Contents ║ A80 ║
NOTE: The * indicates that the field is keyed.
2. Your own Reporting Table should be restructured to have a
field of type A1.
3. In Report Design mode (or Report Change mode), press
[F10], then choose Field | Lookup | Link | Linked.
Specify VARIABLE as the Lookup table name.
4. Link the [Variable Link] field from the VARIABLE table to
the new A1 type field in your reporting table.
5. The A1 type field of both tables must always remain blank
(it cannot contain any data), to ensure the link.
6. Within the reporting table, in order to place the variable
information, place the field [Variable->Variable Contents]
wherever it is needed. Make sure your variable
information has been placed in the [Variable Contents]
field.
7. At output time, the reporting table will look for a match
to the blank value in the linked field. This match will
be the 1st and only record in the VARIABLE table, causing
the variable to be placed on the report.
PRODUCT : Paradox NUMBER : 539
VERSION : 3.0 & up
OS : DOS
DATE : May 7, 1993 PAGE : 2/2
TITLE : Placing a Variable in a Report
Suggested Reading:
If you are using Paradox 4.0, refer to Chapter 8 of the User's
Guide for information on using lookup tables in reports.
If you are using Paradox 3.0 or 3.5, refer to Chapter 4 of the
Presenting Data manual for information on using lookup tables in
reports.
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.